import json
import xlrd
import xlwt

# 使用json.load 读取json文件中的数据，比昂转换为dict_score
with open('../src/高二第二次考试/高二第二次考试.json', 'r') as f:
    dict_score = json.load(f)

personal = dict_score['personal']
class_score_avg = dict_score['class_score_avg']
class_score_top = dict_score['class_score_top']
grade_score_top = dict_score['grade_score_top']


wb = xlwt.Workbook()
sheet = wb.add_sheet('score')

